﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data.SqlClient;
using HK2009.EntityQuery;
using System.Data;

namespace HK2009.BusinessFacade
{
    /// <summary>
    /// 系统配置管理接口
    /// </summary>
    public interface ISyContainerModelHandler
    {
        /// <summary>
        /// 根据sql语句同参数获取柜型列表
        /// </summary>
        /// <param name="sqlStr">sql语句</param>
        /// <param name="parms">参数</param>
        /// <returns></returns>
        DataTable GetModelList(string sqlStr, SqlParameter[] parms);

        /// <summary>
        /// 根据name获取柜型
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        DataTable GetModelList(string name);


        /// <summary>
        /// 根据pkID获取Model
        /// </summary>
        /// <param name="pkID"></param>
        /// <returns></returns>
        Sy_ContainerModelQuery GetModel(int pkID);

        /// <summary>
        /// 根据pkID删除柜型
        /// </summary>
        /// <param name="pkID"></param>
        /// <returns></returns>
        bool ModelDelete(int pkID);

        /// <summary>
        /// 传入实体类进行更新
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        bool ModelUpdate(Sy_ContainerModelQuery query);

        /// <summary>
        /// 传入实体进行添加
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        bool ModelInsert(Sy_ContainerModelQuery query);

       
    }
}
